create procedure [dbo].[BAEEventSetupRemoveQuestion] @id int,
     @eventCode varchar(16) as
DECLARE @thisQuestionorder AS INT

    /* Get question order */        
    SELECT @thisQuestionorder = QuestionOrder
    FROM EventSetupQuestion
    WHERE EventSetupQuestionID=@id;

    /* Update other questions order */
    UPDATE EventSetupQuestion
    SET QuestionOrder = QuestionOrder - 1
    WHERE EventCode = @eventCode AND QuestionOrder > @thisQuestionorder;

    DELETE FROM EventSetupQuestionChoice WHERE EventSetupQuestionID = @id;
    DELETE FROM EventSetupQuestion WHERE EventSetupQuestionID = @id;

GO